CREATE TABLE [dbo].[Users]
(
[UserId] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Users_UserId] DEFAULT (''),
[UserName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Users_UserName] DEFAULT (''),
[Password] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Users_Password] DEFAULT (''),
[Disabled] [bit] NOT NULL CONSTRAINT [DF_Users_Disabled] DEFAULT ((0)),
[LastLogin] [datetime] NULL,
[PreviousLogin] [datetime] NULL,
[ExpirationDate] [datetime] NULL,
[Department] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Users_Department] DEFAULT (''),
[AccessKeywords] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Users_AccessKeywords] DEFAULT (''),
[AdHocAllowed] [bit] NOT NULL CONSTRAINT [DF_Users_AdHocAllowed] DEFAULT ((0)),
[LevelSystem] [tinyint] NOT NULL CONSTRAINT [DF_Users_LevelSystem] DEFAULT ((0)),
[LevelMembership] [tinyint] NOT NULL CONSTRAINT [DF_Users_LevelMembership] DEFAULT ((0)),
[LevelDues] [tinyint] NOT NULL CONSTRAINT [DF_Users_LevelDues] DEFAULT ((0)),
[LevelMeeting] [tinyint] NOT NULL CONSTRAINT [DF_Users_LevelMeeting] DEFAULT ((0)),
[LevelCashAR] [tinyint] NOT NULL CONSTRAINT [DF_Users_LevelCashAR] DEFAULT ((0)),
[LevelOrderEntry] [tinyint] NOT NULL CONSTRAINT [DF_Users_LevelOrderEntry] DEFAULT ((0)),
[LevelReferral] [tinyint] NOT NULL CONSTRAINT [DF_Users_LevelReferral] DEFAULT ((0)),
[LevelCert] [tinyint] NOT NULL CONSTRAINT [DF_Users_LevelCert] DEFAULT ((0)),
[LevelFundRaising] [tinyint] NOT NULL CONSTRAINT [DF_Users_LevelFundRaising] DEFAULT ((0)),
[LevelExpo] [tinyint] NOT NULL CONSTRAINT [DF_Users_LevelExpo] DEFAULT ((0)),
[LevelSC] [tinyint] NOT NULL CONSTRAINT [DF_Users_LevelSC] DEFAULT ((0)),
[DisableInitialScreen] [bit] NOT NULL CONSTRAINT [DF_Users_DisableInitialScreen] DEFAULT ((0)),
[RestrictInternetAccess] [bit] NOT NULL CONSTRAINT [DF_Users_RestrictInternetAccess] DEFAULT ((0)),
[ButtonBarDesign] [bit] NOT NULL CONSTRAINT [DF_Users_ButtonBarDesign] DEFAULT ((0)),
[UseEPWoriMIS] [bit] NOT NULL CONSTRAINT [DF_Users_UseEPWoriMIS] DEFAULT ((0)),
[Signature] [image] NULL,
[StandardClosing1] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Users_StandardClosing1] DEFAULT (''),
[StandardClosing2] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Users_StandardClosing2] DEFAULT (''),
[CheckTickler] [bit] NOT NULL CONSTRAINT [DF_Users_CheckTickler] DEFAULT ((0)),
[EditTypes] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Users_EditTypes] DEFAULT (''),
[MenuItems] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Users_MenuItems] DEFAULT (''),
[PREF_ID] [int] NOT NULL CONSTRAINT [DF_Users_PREF_ID] DEFAULT ((0)),
[ReportDest] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Users_ReportDest] DEFAULT (''),
[PrinterDest] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Users_PrinterDest] DEFAULT (''),
[FileDest] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Users_FileDest] DEFAULT (''),
[PortDest] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Users_PortDest] DEFAULT (''),
[LinesPerPage] [int] NOT NULL CONSTRAINT [DF_Users_LinesPerPage] DEFAULT ((0)),
[CharactersPerLine] [int] NOT NULL CONSTRAINT [DF_Users_CharactersPerLine] DEFAULT ((0)),
[SendFormfeed] [bit] NOT NULL CONSTRAINT [DF_Users_SendFormfeed] DEFAULT ((0)),
[IncludeProspects] [bit] NOT NULL CONSTRAINT [DF_Users_IncludeProspects] DEFAULT ((0)),
[UPDATED_BY] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Users_UPDATED_BY] DEFAULT (''),
[PrinterDestLabels] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Users_PrinterDestLabels] DEFAULT (''),
[IsCasualUser] [bit] NOT NULL CONSTRAINT [DF_Users_IsCasualUser] DEFAULT ((0)),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[Users] ADD CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED ([UserId]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Users] TO [IMIS]
GRANT SELECT ON  [dbo].[Users] TO [IMIS]
GRANT INSERT ON  [dbo].[Users] TO [IMIS]
GRANT DELETE ON  [dbo].[Users] TO [IMIS]
GRANT UPDATE ON  [dbo].[Users] TO [IMIS]
GO